{% extends 'base.html' %}
{% load staticfiles %}
{% block nav-sjkxx %}
    <li>
        <a href="#"><i class="fa fa-globe"></i> 数据库信息<span class="fa arrow"></span></a>
        <ul class="nav nav-second-level collapse in">
            <li>
                <a href="#">生产环境 <span class="fa arrow"></span></a>
                <ul class="nav nav-third-level">
                    <li> <a href="/dbinfo/server_list">生产服务列表</a></li>
                    <li><a href="/dbinfo/server_password_list">生产服务密码表</a></li>
                    <li> <a href="/dbinfo/oracle_user_list">生产ORACLE用户信息表</a></li>
                    <li><a href="/dbinfo/mysql_user_list">生产MYSQL密码表</a></li>
                </ul>
            </li>
            <li>
                <a href="#">办公环境 <span class="fa arrow"></span></a>
                <ul class="nav nav-third-level">
                    <li> <a href="/odbinfo/o_server_list">办公服务列表</a></li>
                    <li><a href="/odbinfo/o_server_password_list">办公服务器密码表</a></li>
                    <li> <a href="/odbinfo/o_oracle_user_list">办公ORACLE用户信息表</a></li>
                    <li><a href="/odbinfo/o_mysql_user_list">办公MYSQL密码表</a></li>
                </ul>
            </li>
        </ul>
    </li>
    <li>
        <a href="#"><i class="fa fa-globe"></i> 上线信息<span class="fa arrow"></span></a>
        <ul class="nav nav-second-level">
            <li> <a href="/issues/event_list">上线列表</a> </li>
            <li> <a href="/issues/system_list">项目列表</a> </li>
        </ul>
    </li>
{% endblock %}
{% block content %}

    <!-- /#page-wrapper -->


    <div id="page-wrapper">
            <div class="row">
                <div class="col-lg-12">
                    <br />
                </div>
                <!-- /.col-lg-12 -->
            </div>
            <!-- /.row -->
            <div class="row">
                <div class="col-lg-12">
                    <div class="panel panel-default">
                        <div class="panel-heading">
                            生产ORACLE用户信息表
                        </div>
                        <!-- /.panel-heading -->
                        <div class="panel-body">
                            <div class="dataTable_wrapper">
                                <table class="table table-striped table-bordered table-hover table-condensed" id="dataTables-example">
                                    <thead>
                                        <tr>
											<th width="10%">服务器</th>
                                            <th width="10%">用户名</th>
											<th width="20%">密码</th>
                                            <th width="10%">状态</th>
                                            <th width="20%">业务</th>
                                            <th width="10%">创建时间</th>
                                            <th width="20%">备注</th>
                                        </tr>
                                    </thead>
                                    <tbody>

{% for user_list in user_lists %}
                                        <tr class="odd gradeX">
                                            <td>{{user_list.dbserver.ip}}</td>
                                            <td>{{ user_list.user }}</td>
                                            <td>{{user_list.passwd }}</td>
                                            <td>{{user_list.status}}</td>
                                            <td>{{user_list.business}}</td>
                                            <td>{{user_list.created}}</td>
                                            <td>{{user_list.comment}}</td>
                                        </tr>
{% endfor %}
                                    </tbody>
                                </table>
                            </div>
                            </div>
                        <!-- /.panel-body -->
                    </div>
                    <!-- /.panel -->
                </div>
                <!-- /.col-lg-12 -->
            </div>
            <!-- /.row -->
        </div>
        <!-- /#page-wrapper -->


{% endblock %}
{% block theme %}
	<!-- Custom Theme JavaScript -->
    <script src="{% static 'js/sb-admin-2.js' %}"></script>
	 <!-- DataTables JavaScript -->
    <script src="{% static 'js/jquery.dataTables.min.js' %}"></script>
    <script src="{% static 'js/dataTables.bootstrap.min.js' %}"></script>

    <!-- Page-Level Demo Scripts - Tables - Use for reference -->
    <script>
    $(document).ready(function() {
        $('#dataTables-example').DataTable({
                responsive: true
        });
    });
    </script>
{% endblock %}







